<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE dita PUBLIC "-//OASIS//DTD DITA Composite//EN" "ditabase.dtd">
<dita>
    <topic xml:lang="en" id="topic1">
        <title>Utility Reference</title>
        <shortdesc>The command-line utilities provided with Greenplum Database.</shortdesc>
        <body>
            <p>Greenplum Database uses the standard PostgreSQL client and server programs and
                provides additional management utilities for administering a distributed Greenplum
                Database DBMS.</p>
            <p>Several utilities are installed when you install the Greenplum Database server. These
                utilities reside in <codeph>$GPHOME/bin</codeph><?oxy_custom_end?>.
                    <ph otherprops="pivotal"> Other utilities must be downloaded from VMware Tanzu
                    Network and installed separately. These include:</ph></p>
            <ul otherprops="pivotal">
                <li>The <xref href="http://gpdb.docs.pivotal.io/backup-restore/latest/index.html"
                        scope="external" format="html">Tanzu Greenplum Backup and Restore</xref>
                    utilities.</li>
                <li otherprops="pivotal">The <xref
                        href="https://gpdb.docs.pivotal.io/gpcopy/latest/index.html"
                        scope="external" format="html">Tanzu Greenplum Copy Utility</xref>.</li>
                <li otherprops="pivotal">The <xref
                        href="http://greenplum.docs.pivotal.io/streaming-server/1-5/ref/gpss-ref.html"
                        scope="external" format="html">Tanzu Greenplum Streaming Server</xref>
                    utilities.</li>
            </ul>
            <p otherprops="pivotal">Additionally, the <xref
                    href="../client_tool_guides/about.xml" scope="peer"
                    >Tanzu Clients</xref> package is a separate download from VMware Tanzu
                Network that includes selected utilities from the Greenplum Database server
                installation that you can install on a client system.</p>
            <p>Greenplum Database provides the following utility programs. <ph otherprops="pivotal"
                    >Superscripts identify those utilities that require separate downloads, as well
                    as those utilities that are also installed with the Client and Loader Tools
                    Packages. (See the Note following the table.) All utilities are installed when
                    you install the Greenplum Database server, unless specifically identified by a
                    superscript.</ph></p>
            <simpletable frame="all" relcolwidth="1.0* 1.0* 1.0*">
                <strow>
                    <stentry>
                        <p><xref href="ref/analyzedb.xml" type="topic" format="dita"/></p>
                        <p><xref href="ref/clusterdb.xml" type="topic" format="dita"/></p>
                        <p><xref href="ref/createdb.xml" type="topic" format="dita"/><sup
                                otherprops="pivotal">3</sup></p>
                        <p><xref href="ref/createlang.xml" type="topic" format="dita"/><sup
                                otherprops="pivotal">3</sup></p>
                        <p><xref href="ref/createuser.xml" type="topic" format="dita"/><sup
                                otherprops="pivotal">3</sup></p>
                        <p><xref href="ref/dropdb.xml" type="topic" format="dita"/><sup
                                otherprops="pivotal">3</sup></p>
                        <p><xref href="ref/droplang.xml" type="topic" format="dita"/><sup
                                otherprops="pivotal">3</sup></p>
                        <p><xref href="ref/dropuser.xml" type="topic" format="dita"/><sup
                                otherprops="pivotal">3</sup></p>
                        <p><xref href="ref/gpactivatestandby.xml" type="topic" format="dita"/></p>
                        <p><xref href="ref/gpaddmirrors.xml" type="topic" format="dita"/></p>
                        <p otherprops="pivotal"><xref href="ref/gpbackup_manager.xml" type="topic"
                                format="dita"/><sup>1</sup></p>
                        <p otherprops="pivotal"><xref href="ref/gpbackup.xml" type="topic"
                                format="dita"/><sup>1</sup></p>
                        <p><xref href="ref/gpcheckcat.xml#topic1"/></p>
                        <p><xref href="ref/gpcheckperf.xml#topic1" type="topic" format="dita"/></p>
                        <p><xref href="ref/gpconfig.xml#topic1" type="topic" format="dita"/></p>
                        <p otherprops="pivotal">
                            <xref href="ref/gpcopy.xml#topic1" type="topic" format="dita" otherprops="pivotal"
                                /><sup>2</sup></p>
                    </stentry>
                    <stentry>
                        <p><xref href="ref/gpdeletesystem.xml#topic1" type="topic" format="dita"
                            /></p>
                        <p><xref href="ref/gpexpand.xml#topic1" type="topic" format="dita"/></p>
                        <p><xref href="ref/gpfdist.xml#topic1" type="topic" format="dita"/><sup
                                otherprops="pivotal">3</sup></p>
                        <p><xref href="ref/gpinitstandby.xml#topic1" type="topic" format="dita"
                            /></p>
                        <p><xref href="ref/gpinitsystem.xml#topic1" type="topic" format="dita"/></p>
                        <p otherprops="pivotal">
                            <xref
                                href="https://greenplum.docs.pivotal.io/streaming-server/1-5/ref/gpss-ref.html"
                                format="html" scope="external">gpkafka</xref><sup>4</sup></p>
                        <p><xref href="ref/gpload.xml#topic1" type="topic" format="dita"/><sup
                                otherprops="pivotal">3</sup></p>
                        <p><xref href="ref/gplogfilter.xml#topic1" type="topic" format="dita"/></p>
                        <p><xref href="ref/gpmapreduce.xml#topic1" type="topic" format="dita"/></p>
                        <p><xref href="ref/gpmapreduce-yaml.xml#topic1" type="topic" format="dita"
                            /></p>
                        <p><xref href="ref/gpmovemirrors.xml" type="topic" format="dita"/></p>
                        <p><xref href="ref/gpmt.xml" type="topic" format="dita"/></p>
                        <p><xref href="ref/gppkg.xml#topic1" type="topic" format="dita"/></p>
                        <p><xref href="ref/gprecoverseg.xml#topic1" type="topic" format="dita"/></p>
                        <p><xref href="ref/gpreload.xml#topic1"/></p>
                        <p otherprops="pivotal"><xref href="ref/gprestore.xml#topic1" type="topic"
                                format="dita"/><sup>1</sup></p>
                        <p><xref href="ref/gpscp.xml#topic1" type="topic" format="dita"/></p>
                        <p otherprops="pivotal"><xref
                                href="https://greenplum.docs.pivotal.io/streaming-server/1-5/ref/gpss-ref.html"
                                format="html" scope="external">gpss</xref><sup>4</sup></p>
                        <p><xref href="ref/gpssh.xml#topic1" type="topic" format="dita"/></p>
                        <p><xref href="ref/gpssh-exkeys.xml#topic1" type="topic" format="dita"/></p>
                    </stentry>
                    <stentry>
                        <p><xref href="ref/gpstart.xml#topic1" type="topic" format="dita"/></p>
                        <p><xref href="ref/gpstate.xml#topic1" type="topic" format="dita"/></p>
                        <p><xref href="ref/gpstop.xml#topic1" type="topic" format="dita"/></p>
                        <p><xref href="ref/pg_config.xml#topic1"/></p>
                        <p><xref href="ref/pg_dump.xml#topic1"/><sup otherprops="pivotal"
                            >3</sup></p>
                        <p><xref href="ref/pg_dumpall.xml#topic1"/><sup otherprops="pivotal"
                            >3</sup></p>
                        <p><xref href="ref/pg_restore.xml#topic1"/></p>
                        <p><xref href="ref/pgbouncer.xml#topic1"/></p>
                        <p><xref href="ref/pgbouncer-ini.xml#topic1"/></p>
                        <p><xref href="ref/plcontainer.xml#topic1" type="topic" format="dita"/></p>
                        <p><xref href="ref/plcontainer-configuration.xml#topic1" type="topic"
                                format="dita"/></p>
                        <p><xref href="ref/psql.xml#topic1"/><sup otherprops="pivotal">3</sup></p>
                        <p><xref href="../../pxf/latest/ref/pxf.html" format="html" scope="external"
                                >pxf</xref></p>
                        <p><xref href="../../pxf/latest/ref/pxf-cluster.html" format="html"
                                scope="external">pxf cluster</xref></p>
                        <p><xref href="ref/reindexdb.xml#topic1"/></p>
                        <p><xref href="ref/vacuumdb.xml#topic1"/></p>
                    </stentry>
                </strow>
            </simpletable>
            <note otherprops="pivotal">
                <p><sup>1</sup> The utility program can be obtained from the <i>Greenplum Backup and
                        Restore</i> tile on <xref
                        href="https://network.pivotal.io/products/pivotal-gpdb-backup-restore"
                        scope="external" format="html"><ph>VMware Tanzu Network</ph></xref>.</p>
                <p><sup>2</sup> The utility program can be obtained from the <i>Greenplum Data Copy
                        Utility</i> tile on <xref
                        href="https://network.pivotal.io/products/gpdb-data-copy" scope="external"
                        format="html"><ph>VMware Tanzu Network</ph></xref>.</p>
                <p><sup>3</sup> The utility program is also installed with the <i>Greenplum Client
                        and Loader Tools Package</i>s for Linux and Windows. You can obtain these
                    packages from the Greenplum Database <i>Greenplum Clients</i> filegroup on <xref
                        href="https://network.pivotal.io/products/pivotal-gpdb" scope="external"
                        format="html"><ph>VMware Tanzu Network</ph></xref>.</p>
                <p><sup>4</sup>The utility program is also installed with the <i>Greenplum Client
                        and Loader Tools Package</i> for Linux. You can obtain the most up-to-date
                    version of the <i>Greenplum Streaming Server</i> from <xref
                        href="https://network.pivotal.io/products/greenplum-streaming-server"
                        scope="external" format="html"><ph>VMware Tanzu Network</ph></xref>.</p>
            </note>
        </body>
    </topic>
</dita>
